Grow Data Skills

Google | Data Application Engineer Interview Experience | 5 YoE

Grow Data Skills
07-Sep-2024
5 mins read

Round 1 - Coding

🔹 You have a machine with 4 buttons - 1st button can increase the time by 60 minutes, 2nd button can increase the time by 15 minutes, 3rd button can increase the time by 5 minutes and 4th button can increase the time by 1 minute. As a input you will be given input timestamp in the format HH:MM and current timestamp will be displayed on the machine, Calculate the minimum number of key presses required to get input time HH:MM from current timestamp

Round 2 - Coding

🔹 You will be given input timestamps in the format HH:MM where 0<=H<=9, 0<=M<=9. Write a code to find next minimum timestamp value which can be generated using same digits of HH:MM

Round 3 - Technical

🔹 Apache Spark related questions - Fundamentals, OOM scenarios in Spark and how to fix them, how to optimize an Spark application, Optimized joins in Spark

🔹 Solve SQL queries for the employee & manager dataset

🔹 Coding question to find the frequency of each character given in a string

Round 4 - Application Design & Domain Knowledge

🔹 Design an Uber kind of application and it’s Data Warehouse

Round 5 - System Integration Knowledge

🔹 Project deep dive discussion based on my resume

🔹 Design real time data ingestion pipeline which will consume data from IoT device and after processing data will be ingested in the realtime in BigQuery

Round 6 - Googliness

🔹 Behavioural and team fitment kind of questions

🔹 Questions around Google’s leadership principles

🔹 Assume you are working for a startup, the CTO has left the company and now you have been given that responsibility. What kind of changes will you bring as per Employee and Employer?

🔹 Let’s say you and your team member are working on a project, your teammate was assigned to come up with a design. You have to review his design and provide your inputs, somehow your teammate is very rigid about his architecture design and not listening to any feedback. Then how would you handle this situation and discuss these things with your manager?

Round 7 - Hiring Manager

🔹 Discussion around my past experience and projects, some resume based questions

🔹 My experience of working on challenging projects and how did I deal with those challenges

Rahul Shukla

Your method of explaining everything in this article is truly pleasant, all be capable of effortlessly be aware of it, Thanks a lot https://www.monebeniste.ca/en/wooden-furniture-restoration/

Rahul Shukla

Your mode of telling all in this article is truly fastidious, every one be able to simply understand it, Thanks a lot https://sepmetrologie.com/quels-sont-les-types-de-metrologie/

Rahul Shukla

Your mode of telling the whole thing in this article is really good, all be able to without difficulty understand it, Thanks a lot https://plomberiejg.ca/services/plomberie-durgence-longueuil/

Rahul Shukla

Your means of telling the whole thing in this article is really nice, every one can without difficulty be aware of it, Thanks a lot https://www.minientrepotssaintcalixte.ca/entrepots-a-st-laurentides/

Rahul Shukla

Your means of telling everything in this post is genuinely fastidious, every one can effortlessly be aware of it, Thanks a lot https://boutiquelemarie.com/costume-de-marie/

Rahul Shukla

Your means of telling all in this paragraph is genuinely fastidious, all be capable of easily be aware of it, Thanks a lot https://www.lescaledetente.com/massage-suedois/

Rahul Shukla

Your way of telling all in this post is truly good, all can effortlessly be aware of it, Thanks a lot https://purlux.ca/fr/nos-services/epilation/electrolyse/

Rahul Shukla

Your means of telling everything in this piece of writing is really nice, all be able to without difficulty be aware of it, Thanks a lot https://institutaxis.com/formations-100-en-ligne/

Rahul Shukla

Your mode of telling all in this post is actually nice, every one can without difficulty understand it, Thanks a lot https://reseaufisconseils.com/qui-peut-beneficier-de-services-dexpert-conseils-en-fiscalite-et-de-deuxieme-opinion/

Rahul Shukla

Your means of describing everything in this post is genuinely nice, every one be able to simply understand it, Thanks a lot https://purlux.ca/fr/nos-services/epilation/electrolyse/

Rahul Shukla

Your way of telling all in this post is genuinely good, all be capable of effortlessly understand it, Thanks a lot https://gouttieresjb.ca

Rahul Shukla

Your method of describing everything in this piece of writing is actually nice, all be capable of effortlessly understand it, Thanks a lot https://www.myozen.ca/en/produit/orthotherapy/